Tabela WMPCONTRACT

Definicja tabeli WMPCONTRACT

Name

WMPCONTRACT

Code

WMPCONTRACT

Comment

umowa WMP


Lista kolumn tabeli WMPCONTRACT

Name

Code

WMPCONTRACTID

WMPCONTRACTID

ACTIVE

ACTIVE

COMMENTARY

COMMENTARY

WMPCONTRACTKIND

WMPCONTRACTKIND

DATEFROM

DATEFROM

DATETO

DATETO

HASLIMIT

HASLIMIT

NAME

NAME


Kolumna WMPCONTRACTID tabeli WMPCONTRACT

Definicja kolumny WMPCONTRACTID tabeli WMPCONTRACT

Name

WMPCONTRACTID

Code

WMPCONTRACTID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

identyfikator


Kolumna ACTIVE tabeli WMPCONTRACT

Definicja kolumny ACTIVE tabeli WMPCONTRACT

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(3)

Mandatory

No

Comment

informacja czy umowa jest aktywna


Kolumna COMMENTARY tabeli WMPCONTRACT

Definicja kolumny COMMENTARY tabeli WMPCONTRACT

Name

COMMENTARY

Code

COMMENTARY

Data Type

VARCHAR2(255)

Mandatory

No

Comment

komentarz do umowy


Kolumna WMPCONTRACTKIND tabeli WMPCONTRACT

Definicja kolumny WMPCONTRACTKIND tabeli WMPCONTRACT

Name

WMPCONTRACTKIND

Code

WMPCONTRACTKIND

Data Type

VARCHAR2(255)

Mandatory

No

Comment

rodzaj umowy WMP (WMP/OMS)


Kolumna DATEFROM tabeli WMPCONTRACT

Definicja kolumny DATEFROM tabeli WMPCONTRACT

Name

DATEFROM

Code

DATEFROM

Data Type

DATE

Mandatory

Yes

Comment

data obowiazywania od


Kolumna DATETO tabeli WMPCONTRACT

Definicja kolumny DATETO tabeli WMPCONTRACT

Name

DATETO

Code

DATETO

Data Type

DATE

Mandatory

Yes

Comment

data obowiazywania do


Kolumna HASLIMIT tabeli WMPCONTRACT

Definicja kolumny HASLIMIT tabeli WMPCONTRACT

Name

HASLIMIT

Code

HASLIMIT

Data Type

NUMBER(38)

Mandatory

No

Comment

informacja czy sa limity


Kolumna NAME tabeli WMPCONTRACT

Definicja kolumny NAME tabeli WMPCONTRACT

Name

NAME

Code

NAME

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

nazwa


Lista kluczy tabeli WMPCONTRACT

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WMPCONTRACT

Definicja klucza Identifier_1 tabeli WMPCONTRACT

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment